Changing Selection Formulas in Web Reports

In addition to specifying a record or group selection formula when designing a report, you can also change the selection formula using a command appended to the URL of a report called through the Web Component Server. As an administrator, you can create one report and design a web page that allows users to choose selection criteria for the information they need. The Web Component Server then dynamically generates the requested report with only the selected records.

To specify a record selection in a request for a web report, use the parameter SF command. For example:

http://server_name/reports/boxoffic.rpt? sf={studio.Studio}+%3d+'Universal'

This overrides any selection formula already contained in Boxoffic.Rpt. However, the new selection formula is not saved with the original report file. It is only valid for the currently requested job. The GF command (group selection) can be used to change a group selection formula in a report.

The Web Component Server does not check the validity of any selection formulas you send to a report. If the selection formula you create is invalid, an error is returned to the web browser. If you are designing a web site that passes selection formulas to reports, be sure to test the selection formulas before allowing users to access your site.



Seagate Software, Inc.
http://www.seagatesoftware.com
Please send comments to:
techpubs@seagatesoftware.com